🏪 Retail Data Lakehouse

Complete Analytics Dashboard - Business Insights + Machine Learning Models
$12.86M
Total Revenue
10,000
Transactions
5,000
Customers
1,000
Products
$1285.78
Avg Transaction

📊 Business Analytics

Revenue by Store
Sales Trend
Customer Distribution
Customer KPIs
Inventory Analysis
Top Products
Marketing Performance

🤖 Machine Learning Models

K-Means clustering identified customer segments for targeted marketing strategies.

⚠️ Slipping Regulars

1,889
Customers
$8.9M
Revenue
$4,710
Avg Spend
70
Days Recency

😴 Dormant Customers

2,392
Customers
$4.0M
Revenue
$1,656
Avg Spend
164
Days Recency
Customer Segmentation

Gradient Boosting model forecasts 30-day product demand for inventory optimization.

206
High Priority
155
Medium
639
Low
34,255
Units to Order

Top 5 Priority Orders

Product Category Stock Order Qty Priority
1737 Home 16 257 HIGH
1902 Sports 8 257 HIGH
1772 Home 11 256 HIGH
1160 Food 7 247 HIGH
1477 Electronics 3 246 HIGH
Forecast Analysis
Forecast Results

Retail Data Lakehouse Project | Medallion Architecture Implementation

Business Analytics + Machine Learning (Customer Segmentation + Demand Forecasting)

Generated: November 4, 2025 | Apache Spark + Delta Lake + Python + scikit-learn